[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '154' >
2 items
DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SickLeaveHours | StartDate | Status | Title | VacationHours |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30 | 32.4519 | 1988-02-28 | Information Services | ashvini0@adventure-works.com | Ashvini Sharma | 656-555-0119 | 749389530 | Ashvini | M | 2019-11-07 | Sharma | adventure-works\ashvini0 | S | R | 154 | 2 | 656-555-0119 | 55 | 2019-11-07 | Current | Network Administrator | 70 | |
192 | 32.4519 | 1991-05-01 | Information Services | peter1@adventure-works.com | Peter Connelly | 310-555-0133 | 672243793 | Peter | M | 2020-01-27 | Connelly | adventure-works\peter1 | S | I | 154 | 2 | 310-555-0133 | 54 | 2020-01-27 | Current | Network Administrator | 69 |
Generated 2025-06-02 18:19:33.829 UTC